﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Kandy/K_Master.master" AutoEventWireup="true" CodeFile="K_Stock.aspx.cs" Inherits="Kandy_K_Stock" %>

<%@ Register Assembly="DevExpress.Web.ASPxGridView.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
 <style type="text/css">
        .style2
        {
            width: 100%;
        }
        .style3
        {
        }
        .style5
        {
        }
        .style6
        {
            width: 159px;
        }
    .style7
    {
        text-align: center;
        font-size: x-large;
    }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
<table class="style2">
        <tr>
            <td class="style3">
                <dx:ASPxGridView  ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" 
                    ClientIDMode="AutoID" DataSourceID="SqlDataSource1" KeyFieldName="IssuSto_ID" 
                    Width="100%" style="margin-left: 0px" 
                    CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
                    CssPostfix="BlackGlass" onhtmlrowprepared="ASPxGridView1_HtmlRowPrepared">
                    <Columns>
                        <dx:GridViewCommandColumn VisibleIndex="0">
                        </dx:GridViewCommandColumn>
                        <dx:GridViewDataTextColumn FieldName="IssuSto_ID" ReadOnly="True" 
                            VisibleIndex="0" Caption="Stock ID">
                            <EditFormSettings Visible="False" />
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="Pro_ID" ReadOnly="True" VisibleIndex="2" 
                            Caption="Item ID">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="Code" VisibleIndex="3" 
                            Caption="Item Code">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="Pro_Name" VisibleIndex="1" 
                            Caption="Item">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="Kandy_Quantity" VisibleIndex="4" 
                            Caption="Quantity ">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="Re_Order_Level" VisibleIndex="5" 
                            Caption="Reorder Level">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="Re_Order_qty" VisibleIndex="6" 
                            Caption="Reorder Quantity">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsPager PageSize="50">
                    </SettingsPager>
                    <Settings ShowFilterRow="True" />
                    <Images SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css">
                        <LoadingPanelOnStatusBar Url="~/App_Themes/BlackGlass/GridView/gvLoadingOnStatusBar.gif">
                        </LoadingPanelOnStatusBar>
                        <LoadingPanel Url="~/App_Themes/BlackGlass/GridView/Loading.gif">
                        </LoadingPanel>
                    </Images>
                    <ImagesFilterControl>
                        <LoadingPanel Url="~/App_Themes/BlackGlass/Editors/Loading.gif">
                        </LoadingPanel>
                    </ImagesFilterControl>
                    <Styles CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
                        CssPostfix="BlackGlass">
                        <Header ImageSpacing="5px" SortingImageSpacing="5px">
                        </Header>
                    </Styles>
                    <StylesEditors>
                        <CalendarHeader Spacing="1px">
                        </CalendarHeader>
                        <ProgressBar Height="25px">
                        </ProgressBar>
                    </StylesEditors>
                </dx:ASPxGridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                    
                    SelectCommand="SELECT [IssuSto_ID], [Pro_Name], [Code], [Re_Order_Level], [Re_Order_qty], [Pro_ID], [Kandy_Quantity] FROM [Tbl_Issue_Stock]">
                </asp:SqlDataSource>
            </td>
        </tr>
        </table>
</asp:Content>

